Tally Request XML formats, Tally Integration with any platform

Tally Request XMLs

Tally Integration, Tally ERP 9 Integration with Node.JS

Tally ERP Data Accessing via Node.js

Getting Tally ERP data using Server side javascript (node.js)

1. Create a NodeJS, express application
2. Install necessary plugins such as cors,xml,body-parser and request.

Server.js

var express = require('express');
var router = express.Router();
var bodyParser = require('body-parser');
var cors = require('cors');
var request = require('request');
require('body-parser-xml')(bodyParser);
var xml = require('xml');
var async = require('async');
/*Tally xml query*/
var xmlstring = '<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export DATA</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<REPORTNAME>LIST of Companies</REPORTNAME>
<STATICVARIABLES>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
</STATICVARIABLES>
</REQUESTDESC>
</EXPORTDATA> </BODY>
</ENVELOPE>';
let app = express();
app.use(bodyParser.json());
/* use CORS to avoid net::ERR_CONNECTION_RESET */
app.use(cors);
app.post("/",(req,res) =>{ /*
Dynamic Tally xml Query parameter
const dbrequest = req.body.datarequest;
const params = req.body.params;
*/
var options = {
uri: 'http://localhost:9000',

method: 'POST',

headers: { 'Content-Type': 'text/xml;
charset:UTF-8',
'Content-Length': Buffer.byteLength(xmlstring)},
body: req.body.xmlstr
};
var result="";
async.parallel([
function(callback) {
/* tally data fetch from local tally server*/
var url = "http://localhost:9000";
request(options, function(err, response, body) {
// JSON body
if(err) { console.log(err);
callback(true);
return;
}

result = body;
callback(false, body);
});

}

],function(err, results) {
if(err) { console.log(err);
res.send(500,"Server Error");
return;
}
res.send("result--->"+result);
}
);
}

app.listen(4000,'localhost');

Party wise Sales in xml format

How to export All Party wise Sales data from tally using XML request

Request for XML Format Party Sales for Integration from Tally.

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>

<BODY>
<EXPORTDATA>
<REQUESTDESC>
         <REPORTNAME>Group Summary</REPORTNAME>
  <STATICVARIABLES>

   <SVCURRENTCOMPANY>company</SVCURRENTCOMPANY>
   <SVEXPORTFORMAT>$$SysName:html</SVEXPORTFORMAT>
   <SVFROMDATE TYPE="Date">#fromdate</SVFROMDATE>
                        <SVTODATE TYPE="Date">#todate</SVTODATE>
                        <DSPShowNett>No</DSPShowNett>


                           <GroupName>22003 SUNDRY DEBTORS</GroupName>
                          <DSPShowTrans>Yes</DSPShowTrans>
                          <IFLTPrompt>Voucher</IFLTPrompt>
                          <IFLTMethod>Invoice</IFLTMethod>
                          <IFLTAttr>Yes</IFLTAttr>

                </STATICVARIABLES>

</REQUESTDESC>

</EXPORTDATA>
</BODY>
</ENVELOPE>

How to Get Trial Balance in xml/html format

How to export trial balance from tally using XML request

Request for a detailed Trial Balance in XML Format from Tally.

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Data</TYPE>
<ID>Trial Balance</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
<EXPLODEFLAG>Yes</EXPLODEFLAG>
<SVEXPORTFORMAT>$$SysName:HTML</SVEXPORTFORMAT>
</STATICVARIABLES>
</DESC>
</BODY>
</ENVELOPE>

XML - How to get voucher list of a specific voucher type in tally via

Tally Request XML for Exporting Sales Vouchers

Tally Integration with Third Party Application using PHP,ASP.NET, VB.Net,JSP

<ENVELOPE>
<HEADER>
<VERSION>1</VERSION>
<TALLYREQUEST>Export</TALLYREQUEST>
<TYPE>Collection</TYPE>
<ID>
List of All Sales Vouchers</ID>
</HEADER>
<BODY>
<DESC>
<STATICVARIABLES>
<SVCURRENTCOMPANY>#CompanyName</SVCURRENTCOMPANY>
<SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
<SVFROMDATE TYPE="Date">fromdate</SVFROMDATE>
<SVTODATE TYPE="Date">todate 23:30:00</SVTODATE>
</STATICVARIABLES>
<TDL>
<TDLMESSAGE>
<COLLECTION NAME="List of All Sales Vouchers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TYPE>Voucher</TYPE>
<FETCH>ADDRESS.LIST,DATE,PARTYNAME,LEDGERENTRIES.LIST</FETCH>
<FILTERS>TYPOFSALES</FILTERS>
</COLLECTION>
<SYSTEM TYPE="Formulae" NAME="TYPOFSALES">
$VOUCHERTYPENAME contains "INVOICE" </SYSTEM>
</TDLMESSAGE>
</TDL>
</DESC>
</BODY>
</ENVELOPE>

$VOUCHERTYPENAME is the name of your Tally Sales Voucher Type

How to Get Outstanding data

How to export Outstanding balance from tally using XML request

Request for a OS details in XML Format from Tally.

<ENVELOPE>
<HEADER>
     <TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
   <EXPORTDATA>
    <REQUESTDESC>
       <REPORTNAME>Bills Payable </REPORTNAME>
         <STATICVARIABLES>
         <SVCURRENTCOMPANY>#company</SVCURRENTCOMPANY>
         <SVEXPORTFORMAT>$$SysName:xml</SVEXPORTFORMAT>
         <SVFROMDATE>#fromdate</SVFROMDATE>
         <SVTODATE>#todate</SVTODATE>
     </STATICVARIABLES>
   </REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>